package net.ruangtedy.java.spring;

import java.util.List;

import javax.sql.DataSource;

public interface StudentDAO {
	
	/**
	 * This is the method to be used to intialize
	 * database resources ie. connection
	 * @param ds
	 */
	public void setDataSource(DataSource ds);
	
	/**
	 * This is the method to be used to list down
	 * a record from the student table corresponding
	 * to a passed student id
	 * @param name
	 * @param age
	 */
	public void create(String name, Integer age);

	
	/**
	 * This is the method to be used to list down
	 * all the record from the Student table
	 * @return
	 */
	public List<Student> listStudents();
	
	/**
	 * This is the method to be used to delete
	 * a record from the Student table corresponding
	 * to a passed student id
	 * @param id
	 */
	public void delete(Integer id);
	
	/**
	 * This is the method to be used to update
	 * a record into the Student table
	 * @param id
	 * @param age
	 */
	public void update(Integer id, Integer age);
	
}
